In [21]:
#Import the modules
import pandas as pd
In [22]:
#Read the csv files
df1 = pd.read_csv(r'D:\breweries.csv')
df1
Out[22]:
ID Name Address Phone Website lat lng
0 1 Wolf Hills Brewing Co 350 Park St SE , Abingdon, VA 24210 276-356-3630 www.wolfhillsbrewing.com 36.712306 -81.965605
1 2 Blue Mountain Brewery 9519 Critzers Shop Rd Route 151, Afton, VA 22920 540-456-8020 www.bluemountainbrewery.com 37.968979 -78.834991
2 3 Quattro Goomba Brewery 22860 James Monroe Hwy , Aldie, VA 20105 703-327-6052 www.goombabrewery.com/ 38.985968 -77.617479
3 4 Hops Grill & Brewery 3625 Jefferson Davis Hwy , Alexandria, VA 22305 703-837-9107 www.hopsonline.com 38.837576 -77.051158
4 5 Port City Brewing Co 3950 Wheeler Ave , Alexandria, VA 22304 703-797-2739 www.portcitybrewing.com 38.808003 -77.101365
5 6 Loose Shoe Brewing Co 198 Ambriar Plz , Amherst, VA 24521 434-946-2337 www.looseshoebrewing.com 37.564995 -79.063519
6 7 Capitol City Brewing Co 2700 S Quincy St , Arlington, VA 22206 703-578-3888 www.capcitybrew.com 38.841165 -77.086909
7 8 Rock Bottom Restaurant - Brewery 4238 Wilson Blvd , Arlington, VA 22203 703-516-7688 www.rockbottom.com 38.878895 -77.110216
8 9 Blue Mountain Barrel House and Organic Brewery 495 Cooperative Way Colleen Business Park, Arr... 434-263-4002 www.bluemountainbarrel.com 37.684031 -78.901133
9 10 Lost Rhino Brewing Co 21730 Red Rum Rd Suite 142, Ashburn, VA 20147 571-291-2083 www.lostrhino.com 39.016129 -77.475568
10 11 Old Ox Brewery 44652 Guilford Dr Suite 114, Ashburn, VA 20147 703-729-8375 oldoxbrewery.com 39.023899 -77.455315
11 12 Center of the Universe Brewing Co 11293 Air Park Rd , Ashland, VA 23005 804-368-0299 www.cotubrewing.com 37.708557 -77.446967
12 13 Beer Hound Brewery 6420 Seminole Trail MOVED 2014, Barboursville,... 434-985-2192 http://www.beerhoundbrewery.com/ 38.185027 -78.327325
13 14 Bull & Bones Brewhaus & Grill 1470 South Main St Suite 120, Blacksburg, VA 2... 540-953-2855 www.bullandbones.com 37.214750 -80.400638
14 15 Callaway Brewing Co 21 Woodwinds Rd , Callaway, VA 24067 540-267-6733 www.callawaybrewingco.com 36.998030 -80.049873
15 16 Chaos Mountain Brewing Co 3135 Dillions Mill Rd , Callaway, VA 24067 540-344-1600 www.chaosmountainbrewing.com 37.112865 -80.067049
16 17 Sweetwater Tavern 6300 Multiplex Dr 14250 Sweetwater Lane, Centr... 703-449-1100 www.greatamericanrestaurants.com 38.829236 -77.439159
17 18 Champion Brewing Co 310 Avon St , Charlottesville, VA 22902 NaN www.championbrewingcompany.com 38.027519 -78.478133
18 19 Champion Brewing Co 324 6th St SE , Charlottesville, VA 22902 434-295-2739 www.championbrewingcompany.com 38.027763 -78.478461
19 20 C'ville-ian Brewing Co 705 W Main St , Charlottesville, VA 22903 800-867-5309 cvillebrewco.com 38.031727 -78.489777
20 21 South Street Brewery 106 South St , Charlottesville, VA 22902- 804-293-6550 www.southstreetbrewery.com 38.029401 -78.482622
21 23 Big Ugly Brewing Co 1296 S Battlefield Blvd Suite 104, Chesapeake,... 757-609-2739 biguglybrewing.com 36.678722 -76.228494
22 24 Starr Hill Brewing Co 5391 Three Notched Rd , Crozet, VA 22932 434-823-5671 www.starrhill.com/Home 38.069262 -78.686645
23 25 Beer Hound Brewery 201 Waters Place #102, Culpeper, VA 22701 540-317-5327 www.beerhoundbrewery.com/ 38.471848 -77.994400
24 26 Damascus Brewery 32173 Government Rd , Damascus, VA 24236 540-314-2782 www.thedamascusbrewery.com 36.639964 -81.802064
25 27 2 Witches Winery and Brewing Co 209 Trade St , Danville, VA 24541 434-549-2739 http://www.2witcheswinebrew.com/ 36.585825 -79.421324
26 28 Swover Creek Farm Brewery 4176 Swover Creek Rd , Edinburg, VA 22824 540-984-8973 http://www.swovercreekfarms.com/ 38.841646 -78.652735
27 29 Coors Brewing Co Rte 340 S , Elkton, VA 22827- 540-289-8000 www.coors.com 38.400588 -78.620251
28 30 Mad Fox Brewing Co 444 W Broad St Suite I, Falls Church, VA 22046 703-942-6840 www.madfoxbrewing.com 38.886318 -77.176935
29 31 Sweetwater Tavern 3066 Gatehouse Plaza Rte 50, Falls Church, VA ... 703-645-8100 www.greatamericanrestaurants.com 38.882334 -77.171091
... ... ... ... ... ... ... ...
72 78 Rock Bottom Restaurant & Brewery 11800 W Broad St , Richmond, VA 23233 804-237-1684 www.facebook.com/RockBottomRichmond/info 37.656729 -77.620216
73 79 Strangeways Brewing Co 2277A Dabney Rd , Richmond, VA 23230 804-303-4336 www.strangewaysbrewing.com 37.586449 -77.483172
74 80 Triple Crossing Brewing Co 113 S Foushee St , Richmond, VA 23220 804-308-0475 www.triplecrossingbeer.com 37.541588 -77.445504
75 81 Big Lick Brewing Co 135 Salem Ave SW , Roanoke, VA 24011 540-562-8383 biglickbrewingco.com 37.272669 -79.943971
76 83 Roanoke Railhouse Brewing Co 3106 Franklin Rd SW , Roanoke, VA 24014 540-293-2423 www.roanokerailhouse.com 37.243907 -79.963026
77 84 Soaring Ridge Craft Brewers 523 Shenandoah Ave NW , Roanoke, VA 24016 540-529-2140 www.facebook.com/pages/Soaring-Ridge-Craft-Bre... 37.275097 -79.950226
78 85 Midnight Brewery 2410 Granite Ridge Rd Rockville Commerce Cente... 804-356-9379 www.midnight-brewery.com 37.698368 -77.665316
79 86 Devils Backbone Brewing Company (Basecamp Brew... 200 Mosby's Run , Roseland, VA 22967 434.361.1001 www.devilsbackbonebrewing.com 37.870497 -78.918887
80 87 Parkway Brewing Co 739 Kessler Mill Rd , Salem, VA 24153 540-314-8234 www.parkwaybrewing.com 37.309198 -80.033478
81 88 James River Brewery 561 Valley St , Scottsville, VA 24590 434-390-7770 www.jamesriverbrewing.com 37.800472 -78.495914
82 89 Hopkins Ordinary Ale Works 47 Main St , Sperryville, VA 22740 540-987-3383 www.hopkinsordinary.com/ale-works 38.657755 -78.226882
83 90 Wild Run Brewing Co (Aquia Pines Camp Resort) 3071 Jefferson Davis , Stafford, VA 22554 540-659-3447 http://www.wildrunbrewing.com/ 38.471717 -77.400595
84 91 Queen City Brewing 834 Springhill Rd , Staunton, VA 24401 540-213-8014 www.qcbrewing.com 38.161636 -79.078892
85 92 Redbeard Brewing Co 120 S Lewis St , Staunton, VA 24401 804-641-9340 www.redbeardbrews.com 38.147566 -79.074594
86 93 Shenandoah Valley Brewing Co 17 Middlebrook Ave , Staunton, VA 24401 540-887-2337 shenvalbrew.com 38.147598 -79.073083
87 94 Beltway Brewing Co 22620 Davis Dr , Sterling, VA 20164 571-989-2739 www.beltwaybrewco.com 38.992233 -77.417394
88 95 Ocelot Brewing Co 23600 Overland Dr #180, Sterling, VA 20166 703-474-3050 ocelotbrewing.com 38.962999 -77.499252
89 96 Sweetwater Tavern 45980 Waterview Plaza Rte 7, Sterling, VA 20166 571-434-6500 www.greatamericanrestaurants.com 39.006699 -77.429130
90 97 Brass Cannon Brewing Co 8105 Richmond Rd #105 , Toano, VA 23168 757-566-0001 www.facebook.com/BrassCannonBrewing 37.387299 -76.805526
91 98 Flying Mouse Brewing Co 221 Precast Way , Troutville, VA 24175 540-992-1288 www.flyingmousebrewery.com 37.409246 -79.900298
92 99 Caboose Brewing Co 520 Mill St NE , Vienna, VA 22180 703-865-8580 www.caboosebrewing.com 38.907732 -77.270579
93 100 Back Bay Brewing Co 614 Norfolk Ave , Virginia Beach, VA 23451 757-531-7750 backbaybrewingco.com/home.html 36.837551 -75.981050
94 101 Gordon Biersch Restaurant Brewery 4561 Virginia Beach Blvd , Virginia Beach, VA ... 757-490-2739 www.gordonbiersch.com 36.843206 -76.134593
95 102 Home Republic Brewing Co 328 Laskin Rd , Virginia Beach, VA 23451 757-226-9593 www.homerepublicvabeach.com 36.859162 -75.980099
96 103 Pleasure House Brewing Co 3025 Shore Dr , Virginia Beach, VA 23451 757-647-8597 www.pleasurehousebrewing.com 36.909833 -76.078121
97 104 Reaver Beach Brewing Co 1505 Taylor Farm Rd NAME CHANGE 2015, Virginia... 757-563-2337 www.reaverbeach.com/ 36.783616 -76.074000
98 105 Young Veterans Brewing Co 2505 Horse Pasture Rd Suite 104, Virginia Beac... 757-689-4021 www.youngveteransbrewco.com 36.786356 -76.055477
99 106 Old Bust Head Brewing Co 7134 Lineweaver Rd , Warrenton, VA 20187 540-347-4777 www.oldbusthead.com 38.744823 -77.675635
100 107 Corcoran Brewing 14635 Corkeys Farm Lane MOVED 2014, Waterford,... 540-882-9073 www.corcoranbrewing.com 39.186789 -77.610038
101 108 Seven Arrows Brewing Co 2508 Jefferson Hwy Suite 1, Waynesboro, VA 22980 540-221-6968 sevenarrowsbrewing.com 38.086856 -78.938778

102 rows × 7 columns

In [23]:
#Get the first ten records of the dataframe
df2 = df1.head(10)
df2
Out[23]:
ID Name Address Phone Website lat lng
0 1 Wolf Hills Brewing Co 350 Park St SE , Abingdon, VA 24210 276-356-3630 www.wolfhillsbrewing.com 36.712306 -81.965605
1 2 Blue Mountain Brewery 9519 Critzers Shop Rd Route 151, Afton, VA 22920 540-456-8020 www.bluemountainbrewery.com 37.968979 -78.834991
2 3 Quattro Goomba Brewery 22860 James Monroe Hwy , Aldie, VA 20105 703-327-6052 www.goombabrewery.com/ 38.985968 -77.617479
3 4 Hops Grill & Brewery 3625 Jefferson Davis Hwy , Alexandria, VA 22305 703-837-9107 www.hopsonline.com 38.837576 -77.051158
4 5 Port City Brewing Co 3950 Wheeler Ave , Alexandria, VA 22304 703-797-2739 www.portcitybrewing.com 38.808003 -77.101365
5 6 Loose Shoe Brewing Co 198 Ambriar Plz , Amherst, VA 24521 434-946-2337 www.looseshoebrewing.com 37.564995 -79.063519
6 7 Capitol City Brewing Co 2700 S Quincy St , Arlington, VA 22206 703-578-3888 www.capcitybrew.com 38.841165 -77.086909
7 8 Rock Bottom Restaurant - Brewery 4238 Wilson Blvd , Arlington, VA 22203 703-516-7688 www.rockbottom.com 38.878895 -77.110216
8 9 Blue Mountain Barrel House and Organic Brewery 495 Cooperative Way Colleen Business Park, Arr... 434-263-4002 www.bluemountainbarrel.com 37.684031 -78.901133
9 10 Lost Rhino Brewing Co 21730 Red Rum Rd Suite 142, Ashburn, VA 20147 571-291-2083 www.lostrhino.com 39.016129 -77.475568
In [24]:
#save as csv & excel file
df2.to_csv(r'D:\breweries1st10.csv')
df2.to_excel(r'D:\breweries1st10.xlsx')
In [10]:
#Check the newly created files
df3 = pd.read_csv(r'D:\breweries1st10.csv')
print df3
df4 = pd.read_excel(r'D:\breweries1st10.xlsx')
df4 = df4.head(5)
df4

   Unnamed: 0  ID                                            Name  \
0           0   1                           Wolf Hills Brewing Co   
1           1   2                           Blue Mountain Brewery   
2           2   3                          Quattro Goomba Brewery   
3           3   4                            Hops Grill & Brewery   
4           4   5                            Port City Brewing Co   
5           5   6                           Loose Shoe Brewing Co   
6           6   7                         Capitol City Brewing Co   
7           7   8                Rock Bottom Restaurant - Brewery   
8           8   9  Blue Mountain Barrel House and Organic Brewery   
9           9  10                           Lost Rhino Brewing Co   

                                             Address         Phone  \
0                350 Park St SE , Abingdon, VA 24210  276-356-3630   
1   9519 Critzers Shop Rd Route 151, Afton, VA 22920  540-456-8020   
2           22860 James Monroe Hwy , Aldie, VA 20105  703-327-6052   
3    3625 Jefferson Davis Hwy , Alexandria, VA 22305  703-837-9107   
4            3950 Wheeler Ave , Alexandria, VA 22304  703-797-2739   
5                198 Ambriar Plz , Amherst, VA 24521  434-946-2337   
6             2700 S Quincy St , Arlington, VA 22206  703-578-3888   
7             4238 Wilson Blvd , Arlington, VA 22203  703-516-7688   
8  495 Cooperative Way Colleen Business Park, Arr...  434-263-4002   
9      21730 Red Rum Rd Suite 142, Ashburn, VA 20147  571-291-2083   

                       Website        lat        lng  
0     www.wolfhillsbrewing.com  36.712306 -81.965605  
1  www.bluemountainbrewery.com  37.968979 -78.834991  
2       www.goombabrewery.com/  38.985968 -77.617479  
3           www.hopsonline.com  38.837576 -77.051158  
4      www.portcitybrewing.com  38.808003 -77.101365  
5     www.looseshoebrewing.com  37.564995 -79.063519  
6          www.capcitybrew.com  38.841165 -77.086909  
7           www.rockbottom.com  38.878895 -77.110216  
8   www.bluemountainbarrel.com  37.684031 -78.901133  
9            www.lostrhino.com  39.016129 -77.475568
Out[10]:
ID Name Address Phone Website lat lng
0 1 Wolf Hills Brewing Co 350 Park St SE , Abingdon, VA 24210 276-356-3630 www.wolfhillsbrewing.com 36.712306 -81.965605
1 2 Blue Mountain Brewery 9519 Critzers Shop Rd Route 151, Afton, VA 22920 540-456-8020 www.bluemountainbrewery.com 37.968979 -78.834991
2 3 Quattro Goomba Brewery 22860 James Monroe Hwy , Aldie, VA 20105 703-327-6052 www.goombabrewery.com/ 38.985968 -77.617479
3 4 Hops Grill & Brewery 3625 Jefferson Davis Hwy , Alexandria, VA 22305 703-837-9107 www.hopsonline.com 38.837576 -77.051158
4 5 Port City Brewing Co 3950 Wheeler Ave , Alexandria, VA 22304 703-797-2739 www.portcitybrewing.com 38.808003 -77.101365
In [25]:
df4.to_excel(r'D:\breweries1st5.xlsx')
In [27]:
pd.read_excel(r'D:\breweries1st5.xlsx')
Out[27]:
ID Name Address Phone Website lat lng
0 1 Wolf Hills Brewing Co 350 Park St SE , Abingdon, VA 24210 276-356-3630 www.wolfhillsbrewing.com 36.712306 -81.965605
1 2 Blue Mountain Brewery 9519 Critzers Shop Rd Route 151, Afton, VA 22920 540-456-8020 www.bluemountainbrewery.com 37.968979 -78.834991
2 3 Quattro Goomba Brewery 22860 James Monroe Hwy , Aldie, VA 20105 703-327-6052 www.goombabrewery.com/ 38.985968 -77.617479
3 4 Hops Grill & Brewery 3625 Jefferson Davis Hwy , Alexandria, VA 22305 703-837-9107 www.hopsonline.com 38.837576 -77.051158
4 5 Port City Brewing Co 3950 Wheeler Ave , Alexandria, VA 22304 703-797-2739 www.portcitybrewing.com 38.808003 -77.101365